Workflow Actions

Process

This is the first step that you take when working with reconciliations. Click Process to update balances for all reconciliations. The Process action has certain requirements to run and has different behavior based on the type of workflow profile association:

  • Base Input Workflow Profile (used to load data): Anyone included in the access group of the workflow profile can click this button to retrieve and update the balances of this workflow profile’s reconciliations. You cannot proceed with the reconciliation until Process Reconciliations is finished.

  • Review level Workflow Profile (reviews data and makes no inputs): Anyone in the Security Role (Manage Reconciliation Setup) user group under Account Reconciliations Global Options can click this button.

    Click the Task Activity icon to show the Process Reconciliations process results:


NOTE: When Process Reconciliations is complete, view updated balances by clicking Show Reconciliations Page .

IMPORTANT: If you run Process in a prior period, you need to run Process in all periods from that period to the current period to ensure the balance activity is updated. For example, if you run Process in M3 and then M2, you need to run Process again in M3 to ensure the balance activity is updated for M3.

FX Translation Warning (Multi-currency Implementations)

You can create detail items before entering FX Rates. This allows you to prepare reconciliations before the close of the period and possibly before the availability of FX Rates. Create a detail item by entering the value and selecting the currency type. If not specified, the detail item currency type defaults to the account currency type. However, the values for Account, Local, and Reporting display as zero (unless the translation is one to one) after saving. Additionally, if OneStream is used to translate either Account or Reporting reconciliation balances from Local, these balances display as zero until FX Rates are entered. The following warning symbols may display:

  • Red FX: FX Rates are not entered for the period.

  • Yellow FX: FX Rates are missing. Hover over the icon to view the missing rates.

  • Yellow FX!: FX Rates are updated, but a Process is necessary.

If necessary, the administrator must run Process to translate all reconciliation balances and detail items for the entire Reconciliation Inventory. An administrator running Process within any reconciliation meets this requirement. 

NOTE: It is strongly recommended that an administrator run Process after entering FX Rates. This ensures that all balances are translated and consistent throughout the solution.

If an administrator enters the FX Rates and does not run Process, end users can still see translated Account and Reporting balances and translated values for detail items, but translation is only performed on reconciliations to which they have access.

All Audit

Only the administrator or users in the Security Role (Manage Reconciliation Setup) user group can run this option. When you click All Audit, a Data Management Sequence called CreateAuditPackage_RCM runs. It generates and exports all reconciliation audit packages for the current workflow view.

This creates multiple compressed folders under a single folder that each contain a reconciliation report and supporting file attachments, as well as a consolidated reconciliation report for all reconciliations.

This Data Management Sequence places its output under the OneStream File Share under Applications/<APPLICATIONNAME>/DataManagement/Export/ as shown here:

Complete Workflow

If you have the appropriate security level and all reconciliations are approved, you can click Complete WF. If you later need to set the workflow in process, you can click Revert Workflow.